How to: Delete a grouping section (when designing a report).
Solution:
In the Report Design view, select the 'View' menu and select 'Sorting and Grouping'. Use the 'Group Header' and 'Group Footer' property boxes for the selected field(s) in the 'Group Properties' window to delete a grouping section in a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Sorting and Grouping'. (The 'Sorting and Grouping' dialog box appears.)
Grouping dialog box
6) Click on the desired field to ungroup in the 'Fields/Expression' box. (The 'Group Properties' window appears at the bottom of the dialog box.)
7) Click on the 'Group Header' box. (A down arrow appears.)
8) Click down arrow. (A drop-down list appears.)
9) Select 'No' from the 'Group Header' drop-down list. (The selected field will NOT be grouped in the header.)
10) Click on the 'Group Footer' box. (A down arrow appears.)
11) Click down arrow. (A drop-down list appears.)
12) Select 'No' from the 'Group Footer' drop-down list. (The selected field will NOT be grouped in the footer.)
13) Repeat steps 6) through 12) for each field to ungroup.
14) Click on the 'X' in the upper right corner of the 'Sorting and Grouping' window to close.
15) Select the 'File' menu and select 'Save' to save the report.
